Fritz: All Fritz/All Fritz.zip/All Fritz/FILES/BUSINESS/CASEMAN1.LZH/LEGAL-A5.EXE/LAWYER.ACS/MERGE.DOC

Text File | 1992-10-14 | 23KB | 595 lines

 áá
                          Import or Output Data:

                                  Import:
            Import a 12 or 13 field ASCII "commß delimitedó file.
                      see options '7', '8', 'B', or 'D'

                                  Output:
     WordStar[TM]/MailMerge[TM]/WordPerfect[TM]/Microsoft [TM] Word 4.0
       dBASE III [TM]/SBT [TM]/SourceMate [TM]/MagniFile/ASCII  Output
                        Basica/Output Sequential File

                                 Overview:
                               Options 1 - 6

Thesσ option≤ creatσ eithe≥ ß WordStar/MailMerge[TM]¼ ASCII¼ WordPerfect[TM]¼ ì
MagniFile¼ o≥ dBAS┼ II╔ [TM▌ datß filσ usinτ thσ datß froφ you≥ maiε datß ì
files«  Thσ newl∙ createΣ filσ end≤ iε thσ letters║ '.DAT'¼ .DEF'¼ '.SFº o≥ ì
'.DBF'.

Iµ useΣ witΦ Wordstar[TM]¼ thσ .DA╘ filσ caε bσ useΣ t∩ prin⌠ forφ letter≤ iε ì
MailMerge[TM]«  Al∞ characte≥ field≤ arσ  trimmeΣ oµ trailinτ blank≤ t∩ ì
accommodatσ you≥ forφ letters«   Alonτ witΦ thi≤ datß file¼ thσ Wordsta≥  ì
optioε create≤ thσ beginninτ oµ  you≥ forφ lette≥ anΣ put≤ i⌠ iε ß filσ ì
endinτ iε thσ │ letter≤ '.DEFº (containinτ al∞ thσ MailMerge[TM▌ command≤ yo⌡ ì
neeΣ a⌠ thσ star⌠ oµ ß forφ letter)«

Iµ useΣ witΦ WordPerfect[TM]¼ thσ .S╞ filσ i≤ thσ 'Secondar∙ Fileº tha⌠ ì
WordPerfec⌠ use≤ fo≥ mergσ letters¼  wherσ eacΦ fielΣ i≤ delimiteΣ witΦ ì
CONTROL-R¼ anΣ eacΦ recorΣ i≤ delimiteΣ witΦ CONTROL-E.]

Iµ useΣ witΦ dBAS┼ II╔ [TM]¼ thσ '.DBFº filσ forma⌠ i≤ becominτ ß standarΣ ì
datß filσ forma⌠ tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥ thei≥ respectivσ datß ì
impor⌠ function.

Wheε useΣ witΦ Microsof⌠ [Reg« TM▌ WorΣ 4.0¼ thσ '.DATº filσ contain≤ thσ ì
datß o≥ record≤ tha⌠ thσ WorΣ 4.░ mergσ documen⌠ requires«



Thesσ option≤  wil∞ allo≈ yo⌡ t∩ outpu⌠ thσ ke∙ field≤ iε you≥ maiε persoε ì
filσ t∩ aε externa∞ tex⌠ filσ tha⌠ can¼ iε turn¼ bσ useΣ b∙ ß worΣ processo≥ ì
t∩ creatσ 'boilerplateº o≥ forφ letter≤ fo≥ yo⌡ automatically.

BaseΣ oε you≥ selectioε criteria¼ iµ any¼ thσ prograφ wil∞ outpu⌠ thesσ ì
fields║
     Se° ID¼ Firs⌠ name¼ Greeting¼ Las⌠ name¼ Compan∙ Name¼ Address1/2
              City¼ State¼ Zip, Zip4¼ Phonσ number¼ Comment≤


                               ==============
                               |  OPTION 1: |
                               ==============

                             Selection Process:è
A⌠ optioε 1¼ yo⌡ caε inpu⌠ u≡ t∩ ╖ searcΦ criteriß a≤ thσ basi≤ fo≥
you≥ worΣ processo≥ mergσ file║

             Las⌠ Name¼ Firs⌠ Name¼ Company¼ City¼ State¼ Zip,
                               anΣ Comments.

Yo⌡ caε selec⌠ whethe≥ yo⌡ wan⌠ onl∙ thosσ record≤ t∩  bσ  selecteΣ  tha⌠  ì
havσ al∞ oµ criteriß iε ever∙ recorΣ o≥ selec⌠ ou⌠  record≤ regardles≤ oµ thσ ì
numbe≥ oµ  matche≤ madσ pe≥ record¼  a≤ lonτ a≤ a⌠  leas⌠ onσ matcΦ i≤ madσ ì
iε an∙ onσ recorΣ tha⌠ i≤ selected.

Truσ  [o≥ T▌ mean≤ al∞ matche≤ havσ t∩ bσ madσ iε an∙ onσ recorΣ fo≥ i⌠  t∩
bσ  selected«   Falsσ  [o≥ F▌ mean≤ tha⌠ a≤ lonτ a≤ onσ matcΦ i≤ madσ iε  ß
recorΣ i⌠ wil∞ bσ selected.



                         Search Criteria Selection:
                                 Option 1:

Yo⌡ caε ente≥ an∙ word¼  phrase¼  o≥ codσ oε whicΦ t∩  basσ you≥ selection«  ì
Iµ lef⌠ blank¼  al∞ record≤ wil∞ bσ selecteΣ out«   Iµ yo⌡ makσ aε entr∙ ì
here¼  thσ prograφ wil∞ searcΦ througΦ thσ maiε persoε filσ anΣ  selec⌠ ou⌠ ì
onl∙ thosσ record≤ tha⌠ mee⌠ you≥ searcΦ criteria.

[Notσ tha⌠ yo⌡ caε havσ u≡ t∩ ╖ differen⌠ code≤ o≥ phrase≤ entereΣ herσ anΣ ì
al∞  record≤ wil∞ bσ pulleΣ whicΦ havσ an∙ onσ oµ theφ  o≥ an∙  combinatioε ì
oµ them]

                               ==============
                               |  OPTION 2: |
                               ==============

                              2)  Other Output:

┴ submen⌡ tha⌠ output≤ t∩ WordStar[TM]/MailMerge[TM]¼ ASCII¼ Microsof⌠ [TM▌ ì
WorΣ 4.░ o≥ variablσ MagniFile«  Thi≤ men⌡ contain≤ it≤ owε Hel≡ screen.


                               ==============
                               ⁿ  OPTIO╬ 3║ |
                               ==============

                   3)  Output records to WordPerfect[TM]
            [outputs into a 14 field, CONTROL-R delimited file]

                             fields outputted:
      SEX,FNAME,GREETING,LNAME,PROSPECT,ADDRESS1,ADDRESS2,CITY,STATE
                    ZIP,ZIP4,PHONE-1,COMMENT1,COMMENT2

Thσ .S╞ filσ i≤ thσ 'Secondar∙ Fileº tha⌠  WordPerfec⌠ use≤ fo≥ mergσ ì
letters¼  wherσ eacΦ fielΣ i≤ delimiteΣ witΦ CONTROL-R¼ anΣ eacΦ recorΣ i≤ ì
delimiteΣ witΦ CONTROL-E.]
èBσ surσ t∩ retrievσ thσ 'Secondar∙ Fileº int∩ WordPerfect¼ a⌠ whicΦ timσ ì
WordPerfec⌠ wil∞ inser⌠ it≤ printe≥ codes«  Then¼ whilσ insidσ WordPerfect¼ ì
savσ thσ filσ unde≥ tha⌠ samσ name«  A⌠ thi≤ point¼ thσ 'Secondar∙ Fileº wil∞ ì
bσ usablσ fo≥ purpose≤ oµ mai∞ merging.

                           [Simila≥ t∩ optioε A]

                               ==============
                               |  OPTION 4: |
                               ==============

               4)  Output records to dBASE III [Registered TM]


WitΦ optioε 4¼ thσ '.DBFº filσ forma⌠ i≤ becominτ ß standarΣ datß filσ ì
forma⌠ tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥ thei≥ respectivσ datß impor⌠ ì
function«

B∙ default¼ thσ prograφ wil∞ outpu⌠ ß simplifieΣ versioε oµ thσ maiε persoε ì
file«  Oncσ yo⌡ assigε ß namσ t∩ thσ dBAS┼ II╔ [TM▌ filσ yo⌡ arσ outputting¼ ì
thσ structurσ oµ tha⌠ filσ is:

Field  Field Name  Type       Width    Dec
    1  SEX         Character     19
    2  FNAME       Character     20
    3  GREETING    Character     20
    4  LNAME       Character     20
    5  PROSPECT    Character     40
    6  ADDRESS1    Character     30
    7  ADDRESS2    Character     30
    8  CITY        Character     30
    9  STATE       Character      2
   10  ZIP         Numeric        5  < numeric representation of Zip codes
   11  ZIP4        Numeric        4  < numeric representation of Zip+4 codes
   12  ZIP_CH      Character      5  < character representation of Zip codes
   13  ZIP4_CH     Character      4  < character representation of Zip+4 codes
   14  PHONE_1     Character     13
   15  COMMENT1    Character     60
   16  COMMENT2    Character     60
   17  CATEGORY    Numeric        8
   18  PRIORITY    Numeric        4
   19  REFERBY     Character     30
   20  FIRST_DATE  Character     10
   21  TITLE       Character     35

** Total **                     450

Thσ numeriπ zi≡ codσ field≤ dro≡ leadinτ zeros¼ whilσ thσ characte≥ one≤ adΣ ì
theφ back.

Iµ yo⌡ invokσ thσ Selectioε Criteriß Men⌡ iε optioε 1¼ theε thσ prograφ wil∞ ì
asδ yo⌡ iµ yo⌡ wisΦ t∩ outpu⌠ froφ thσ maiε persoε o≥ Activit∙ file«  Iµ yo⌡ ì
selec⌠ thσ latter¼ theε thi≤ filσ i≤ outputted:

èField  Field Name  Type       Width    Dec
    1  SEX         Character     19
    2  FNAME       Character     20
    3  LNAME       Character     20
    4  PROSPECT    Character     40
    5  ADDRESS1    Character     30
    6  ADDRESS2    Character     30
    7  CITY        Character     30
    8  STATE       Character      2
    9  ZIP         Numeric        5
   10  ZIP_CH      Character      5
   11  PHONE_1     Character     13
   12  COMMENT1    Character    200
   13  CATEGORY    Numeric        8
   1┤  CALLBAC╦    Characte≥     1░
   15  FIRST_DATE  Character     10
** Total **                     443


Observσ tha⌠ ß callbacδ datσ appear≤ iµ an∙ onl∙ iµ yo⌡ havσ entereΣ ß datσ ì
othe≥ thaε '01/01/1901º iε thσ Callbacδ fielΣ oµ thσ activit∙ record«   ì
Wheneve≥ thσ prograφ see≤ '01/01/1901º iε thσ callbacδ fielΣ oµ thσ ì
activity¼ theε i⌠ assume≤ tha⌠ yo⌡ havσ n∩ callbacδ anΣ doe≤ no⌠ outpu⌠ ì
anythinτ int∩ fielΣ 1┤ above«

Notσ als∩ tha⌠ FIRST_DAT┼ i≤ thσ datσ wheε thi≤ recorΣ wa≤ firs⌠ entereΣ ì
int∩ thσ program.

                               ==============
                               |  OPTION 5: |
                               ==============

Thi≤ optioε wil∞ appenΣ record≤ directl∙ t∩ thσ SB╘ [TM▌ custome≥ file.


                               ==============
                               |  OPTION 6: |
                               ==============

Thi≤ optioε wil∞ appenΣ record≤ directl∙ t∩ thσ SourceMatσ [TM▌ custome≥ ì
file.

                               ==============
                               |  OPTION 7: |
                               ==============


                  "7⌐  1▓ fielΣ o≥ 11▓ FielΣ ASCI╔ importó

Optioε 7 givσ yo⌡ tw∩ nesteΣ selections║ 1▓ fielΣ o≥ 11▓ FielΣ ASCI╔ import«  ì
Thσ '11▓ Fieldº selectioε i≤ ß variablσ MagniFilσ [TM▌ ASCI╔ impor⌠ feature«

T∩ usσ thi≤ Variablσ 11▓ FielΣ ASCI╔ impor⌠ feature¼ yo⌡ mus⌠ enter
thσ tota∞ numbe≥ oµ field≤ cominτ in«  Thσ firs⌠ 1▓ g∩ int∩ the
maiε persoε file¼ whilσ thσ res⌠ linδ int∩ MagniFilσ [TM]¼ thougΦ yo⌡ arσ ìèno⌠ requireΣ t∩ avai∞ yourselµ oµ al∞ 11▓ fields«

Iµ yo⌡ wisΦ t∩ usσ thσ variablσ MagniFilσ [TM▌ ASCI╔ impor⌠ g∩ thσ thσ Maiε ì
Prograφ Menu¼ selec⌠ optioε 1«  Afte≥ havinτ donσ that¼ ente≥ 'Gº fo≥ thσ ì
Ge⌠ screen«  Oncσ there¼ ente≥ 'F2º fo≥ thσ MagniFilσ [TM▌ Menu¼ theε reaΣ ì
thσ MagniFilσ [TM▌ Hel≡ screeε b∙ enterinτ 'H'.


                        Import data from ASCII file:

áááCreatσ aε ASCI╔ "commß delimitedó filσ witΦ thesσ 12 fields:

áááFirs⌠ namσ     <=╜ u≡ t∩ 2░ characters
áááLas⌠ namσ      <=╜ u≡ t∩ 2░ characters
áááCompan∙ namσ   <=╜ u≡ t∩ 4░ characters
áááAddres≤ ▒      <=╜ u≡ t∩ 3░ characters¼ firs⌠ linσ oµ addres≤
áááAddres≤ ▓á     <=╜ u≡ t∩ 3░ characters¼á2nΣ line¼áiµ any¼ásucΦáa≤
                   ááá'Suitσ 214'
áááCit∙           <=╜ u≡ t∩ 3░ characters
áááStatσ          <=╜ tw∩ characte≥ state¼ iµ U.S.A.╗ elsσ leavσ blank
áááZi≡            <=╜ U.S.A« Zi≡ code¼ ╡ characters
áááZi≡4           <=╜ U.S.A« Supplemental Zi≡ code¼ 4 characters
áááPhonσ          <=╜ 1│ character¼ iµ .U.S.A« o≥ Canada« Mus⌠ be
                      in this form:  [phone]
                      Observe character 1 is '(', 5 is ')', and 9 is '-'
áááComment1       <== any comment, up to 60 characters
   Sex ID         <== if used, such as 'Dr.', 'Captain', or 'Reverend'

Optioε ╖ wil∞ impor⌠ froφ aε ASCI╔ filσ named║ 'AIMPORT.TXT'«  Makσ surσ tha⌠ ì
you≥ filσ ha≤ tha⌠ name.

Observσ belo≈ onσ recorΣ iε thσ ASCI╔ "commß delimitedó format:


   "John D.","Cauble, Jr.","Accounting & Tax Service","11056 Shady Trail",
      "Suite 101","Dallas","TX","75229","0234","[phone]","SIC=4303",""


Observσ tha⌠ "Suitσ 101ó  woulΣ normall∙ follo≈ afte≥ "1105╢ Shad∙ Trailó oε ì
onσ continuou≤ line«  Herσ thσ recorΣ i≤ brokeε int∩ tw∩ line≤ onl∙ fo≥ ì
purpose≤ oµ showinτ yo⌡ ho≈ i⌠ looks.





                               ==============
                               |  OPTION 8: |
                               ==============

                        Import data from ASCII file:

Creatσ aε ASCI╔ "commß delimitedó filσ witΦ thesσ 1│ fields:

áááFirs⌠ namσ     <=╜ u≡ t∩ 2░ charactersèáááLas⌠ namσ      <=╜ u≡ t∩ 2░ characters
áááCompan∙ namσ   <=╜ u≡ t∩ 4░ characters
áááAddres≤ ▒      <=╜ u≡ t∩ 3░ characters¼ firs⌠ linσ oµ addres≤
áááAddres≤ ▓á     <=╜ u≡ t∩ 3░ characters¼á2nΣ line¼áiµ any¼ásucΦáa≤
                   ááá'Suitσ 214'
áááCit∙           <=╜ u≡ t∩ 3░ characters
áááStatσ          <=╜ tw∩ characte≥ state¼ iµ U.S.A.╗ elsσ leavσ blank
áááZi≡            <=╜ U.S.A« Zi≡ code¼ ╡ characters
áááZi≡4           <=╜ U.S.A« Supplemental Zi≡ code¼ 4 characters
áááPhonσ          <=╜ 1│ character¼ iµ .U.S.A« o≥ Canada« Mus⌠ be
                      in this form:  [phone]
                      Observe character 1 is '(', 5 is ')', and 9 is '-'
áááComment1       <== any comment, up to 60 characters
   Sex ID         <== if used, such as 'Dr.', 'Captain', or 'Reverend'
   Revenue/Expense<== Any value entered here will cause a corresponding
                      first record in the Activity file to be created.

Optioε ╕ wil∞ impor⌠ froφ aε ASCI╔ filσ named║ 'AIMPORT.TXT'«  Makσ surσ tha⌠ ì
you≥ filσ ha≤ tha⌠ name«

Observσ belo≈ onσ recorΣ iε thσ ASCI╔ "commß delimitedó format:


   "John D.","Cauble, Jr.","Accounting & Tax Service","11056 Shady Trail",
      "Suite 101","Dallas","TX","75229","0234","[phone]",
      "SIC=4303","Mr.","5412.43"


Observσ tha⌠ "Suitσ 101ó  woulΣ normall∙ follo≈ afte≥ "1105╢ Shad∙ Trailó oε ì
onσ continuou≤ line«  Herσ thσ recorΣ i≤ brokeε int∩ tw∩ line≤ onl∙ fo≥ ì
purpose≤ oµ showinτ yo⌡ ho≈ i⌠ looks«  Yo⌡ arσ no⌠ requireΣ t∩ ente≥ ß valuσ ì
fo≥ thσ Revenue/Expensσ field«  Iµ yo⌡ do¼ theε thσ prograφ wil∞ creatσ ß ì
correspondinτ recorΣ iε thσ activit∙ file«

Onσ applicatioε oµ thi≤ woulΣ bσ iµ yo⌡ arσ bringinτ iε record≤ froφ aε ì
Account≤ Receivablσ file¼ witΦ aε amoun⌠ oweΣ fo≥ eacΦ debtor«


                               ==============
                               |  OPTION 9: |
                               ==============

         "9)  Select date range [works with #2,3,4,5 A and C only]"


Optioε ╣ i≤ t∩ changσ thσ star⌠ o≥ sto≡ datσ oε thσ option≤ t∩ Impor⌠ o≥ ì
Outpu⌠ Data«  I⌠ default≤ t∩ thesσ dates:

   STAR╘ DAT┼ :'01/01/1901'
   STO╨ DAT┼  :'12/12/2999º

Notσ tha⌠ thi≤ datσ rangσ selectioε wil∞ worδ onl∙ witΦ selection≤ #2¼ 3¼ 4¼ ì
5¼ A¼ o≥ ├ oε thi≤ menu.

è
                               ==============
                               ⁿ  OPTIO╬ A║ |
                               ==============

                   A)  Output records to WordPerfect[TM]
            [outputs into a 17 field, CONTROL-R delimited file]

                             fields outputted:
      SEX,FNAME,GREETING,LNAME,PROSPECT,ADDRESS1,ADDRESS2,CITY,STATE
       ZIP,ZIP4,PHONE-1,COMMENT1,COMMENT2,CATEGORY,PRIORITY,REFERBY

Thσ .S╞ filσ i≤ thσ 'Secondar∙ Fileº tha⌠  WordPerfec⌠ use≤ fo≥ mergσ ì
letters¼  wherσ eacΦ fielΣ i≤ delimiteΣ witΦ CONTROL-R¼ anΣ eacΦ recorΣ i≤ ì
delimiteΣ witΦ CONTROL-E.]

Bσ surσ t∩ retrievσ thσ 'Secondar∙ Fileº int∩ WordPerfect¼ a⌠ whicΦ timσ ì
WordPerfec⌠ wil∞ inser⌠ it≤ printe≥ codes«  Then¼ whilσ insidσ WordPerfect¼ ì
savσ thσ filσ unde≥ tha⌠ samσ name«  A⌠ thi≤ point¼ thσ 'Secondar∙ Fileº wil∞ ì
bσ usablσ fo≥ purpose≤ oµ mai∞ merging.

                            [Similar to option 3]



                               ==============
                               ⁿ  OPTIO╬ B║ |
                               ==============


                       Import data from ASCII file:

       Creatσ aε ASCI╔ "commß delimitedó filσ witΦ thesσ 24 fields:
                      [Bring data into the Detail File]

áááFirs⌠ namσ     <=╜ u≡ t∩ 2░ characters
áááLas⌠ namσ      <=╜ u≡ t∩ 2░ characters
áááCompan∙ namσ   <=╜ u≡ t∩ 4░ characters
áááAddres≤ ▒      <=╜ u≡ t∩ 3░ characters¼ firs⌠ linσ oµ addres≤
áááAddres≤ ▓á     <=╜ u≡ t∩ 3░ characters¼á2nΣ line¼áiµ any¼ásucΦáa≤
                   ááá'Suitσ 214'
áááCit∙           <=╜ u≡ t∩ 3░ characters
áááStatσ          <=╜ tw∩ characte≥ state¼ iµ U.S.A.╗ elsσ leavσ blank
áááZi≡            <=╜ U.S.A« Zi≡ code¼ ╡ characters
áááZi≡4           <=╜ U.S.A« Supplemental Zi≡ code¼ 4 characters
áááPhonσ          <=╜ 1│ character¼ iµ .U.S.A« o≥ Canada« Mus⌠ be
                      in this form:  [phone]
                      Observe character 1 is '(', 5 is ')', and 9 is '-'
áááComment1       <== any comment, up to 60 characters
   Sex ID         <== if used, such as 'Dr.', 'Captain', or 'Reverend'
   Detail 1       <== up to 20 characters, placed into the Detail File,
                       field one.
   Detail 2       <== up to 20 characters
   Detail 3       <== up to 20 characters
   Detail 4       <== up to 20 charactersè   Detail 5       <== up to 20 characters
   Detail 6       <== up to 20 characters
   Detail 7       <== up to 20 characters
   Detail 8       <== up to 20 characters
   Detail 9       <== up to 20 characters
   Detail 10      <== up to 20 characters
   Detail 11      <== up to 20 characters
   Detail 12      <== up to 20 characters


Optioε ┬ wil∞ impor⌠ froφ aε ASCI╔ filσ named║ 'AIMPORT.TXT'«  Makσ surσ tha⌠ ì
you≥ filσ ha≤ tha⌠ name.

Observσ belo≈ onσ recorΣ iε thσ ASCI╔ "commß delimitedó format:


"Alyce","Fisher","P.O. BOX","2116 E. Arapaho","P.O. Box 3823","Richardson",
"TX","75081","0433","[phone]",
"they currently have an 8bit system, written in compiled",
"Mr.","DET1","DET2","DET3","DET4","DET5","DET6","DET7","DET8",
"DET9","DET10","DET11","DET12"


Observσ tha⌠ thi≤ recorΣ woulΣ normall∙ bσ oε onσ continuou≤ line¼á bu⌠á i≤ ì
herσ brokeε int∩ fivσ line≤ onl∙ fo≥ purpose≤ oµ showinτ yo⌡ ho≈ i⌠ looks.



                               ==============
                               ⁿ  OPTIO╬ C║ |
                               ==============

                   C)  Output records to WordPerfect[TM]
            [outputs into a 20 field, CONTROL-R delimited file]

                             fields outputted:
      SEX,FNAME,GREETING,LNAME,PROSPECT,ADDRESS1,ADDRESS2,CITY,STATE
       ZIP,ZIP4,PHONE-1,COMMENT1,COMMENT2,CATEGORY,PRIORITY,REFERBY
                             DATE,AMOUNT,TITLE

Thσ .S╞ filσ i≤ thσ 'Secondar∙ Fileº tha⌠  WordPerfec⌠ use≤ fo≥ mergσ ì
letters¼  wherσ eacΦ fielΣ i≤ delimiteΣ witΦ CONTROL-R¼ anΣ eacΦ recorΣ i≤ ì
delimiteΣ witΦ CONTROL-E.]

Bσ surσ t∩ retrievσ thσ 'Secondar∙ Fileº int∩ WordPerfect¼ a⌠ whicΦ timσ ì
WordPerfec⌠ wil∞ inser⌠ it≤ printe≥ codes«  Then¼ whilσ insidσ WordPerfect¼ ì
savσ thσ filσ unde≥ tha⌠ samσ name«  A⌠ thi≤ point¼ thσ 'Secondar∙ Fileº wil∞ ì
bσ usablσ fo≥ purpose≤ oµ mai∞ merging.

'DATEºá i≤ thσ datσ oµ origina∞ entr∙ int∩ thσ program«á  'AMOUNTºá i≤á thσ ì
revenue/expensσ item.

                           [Similar to option 3]

è
                               ==============
                               ⁿ  OPTIO╬ D║ |
                               ==============

                        "D)  Dun's [TM] ASCII import"

Dun'≤ Marketinτ Service≤ [TM▌ offer≤ aε outstandinτ databasσ inquir∙ servicσ ì
fo≥ sale≤ anΣ marketinτ professional≤ calleΣ Dun'≤ Direc⌠ Acces≤ [TM]« Fo≥ ì
morσ informatioε oε thei≥ offerings¼ pleasσ call:

Dun'≤ Marketinτ Services
Threσ Sylvaε Way
Parsippany¼ N╩  0705┤  -3896

[phone]
(201)605-642┤



Iµ yo⌡ havσ an∙ question≤ abou⌠ Dun'≤ Translato≥ o≥ havσ technica∞ questions¼ ì
pleasσ cal∞ thσ Duε ª Bradstree⌠ Custome≥ Suppor⌠ Cente≥ a⌠ 1-800-526-4590.

(201-464-780│ iε Ne≈ Jersey).


Thσ followinτ filσ format≤ arσ availablσ withiε Dun'≤ Direc⌠ Access¼ Versioε ì
3.0:


192 - Dun's Mailing Record
204 - Personalized DDM - One Name
260 - Dun's Telemarketing File
560 - Dun's Market Identifiers (DMI)
576 - Dun's Market Identifiers - Personalized
616 - Dun's Market Identifiers w/Trends Enhanced
706 - Dun's Market Identifiers w/AOS Enhanced
1129 - Enhanced Dun's Market Identifiers (EDMI)
1181 - EDMI Personalized Name
1331 - Enhanced Dun's Market Identifiers Plus
1383 - EDMI Plus Personalized Name
1782 - Dun's Executive Marketing Summaries (DEMS)
3062 - Dun's Executive Marketing Summaries (DEMS)
1918 - Dun's Executive Marketing Summaries (DEMS)
501 - International Dun's Market Identifiers
450 - Million Dollar File
450 - Metalworking File
536 - Asset Based Lending Master File
295 - Asset Based Lending Filings File
141 - Asset Based Lending Filings File
178 - Trinc Mailing File
266 - Trinc Mailing File
375 - Trinc Owner & User File
447 - Trinc File w/Personalization
589 - Trinc Full File                             è139 - Erisa Red (Pension Plans)
210 - Erisa Red (Pension Plans)
530 - Erisa Selling File
245 - Keogh
200 - MAP File
215 - MAP File
332 - MAP File
201 - UCC Mailing Label Record file
768 - UCC 768 file
640 - UCC Construction Equipment
640 - UCC Standard Office Products
768 - UCC Standard Office Products
840 - UCC 840 file
830 - UCC 830 Office Products file
522 - Metalworking - Personalized
660 - International Corporate Affiliations
530 - Broker's Ally

T∩ impor⌠ datß int∩ thi≤ program¼á pleasσ selec⌠ thσ 57╢ characte≥ StandarΣ ì
DM╔ record:

               576 - Dun's Market Identifiers - Personalized




Dun'≤ [TM▌ output≤ it≤ field≤ iε thi≤ form:



1.DUNS Number
2.Business Name
3.Secondary Trade Name
4.Street Address
5.City
6.State
7.Physical Zip Code
8.Mailing Address
9.Mailing City
10.Mailing State
11.Mailing Zip Code
12.Carrier Route Code
13.Package Level Code
14.Geo  Codes D&B/FIPS
15.National Code
16.State Code
17.County Code
18.City Code/MSA Code
19.SMSA Code
20.Telephone Area Code
21.Telephone Number
22.Full Telephone Number
23.Full Exec Name
24.First Name
25.Middle Initial è26.Last Name
27.Suffix
28.Prefix
29.Title
30.MRC
31.Sales Volume
32.Code for EST/Range
33.Employees Total
34.Code for ACT/Range
35.Employees Here
36.Code for ACT/Range
37.Year Started
38.Status Indicator
39.Subsidiary Indicator
40.Manufacturing Indic
41.Ultimate DUNS
42.Headquarters DUNS
43.Parent DUNS
44.Headquarters City
45.Headquarters State
46.Foreign Ult. DUNS
47.Foreign Parent DUNS
48.Hierarchy Code
49.DIAS Code
50.Population Code
51.Transaction Code
52.Report Date
53.User Area
54.Record Class Type
55.Line of Business
56.SIC Code 1
57.SIC Code 2
58.SIC Code 3
59.SIC Code 4
60.SIC Code 5
61.SIC Code 6
62.NULL
63.Last Item



T∩ seσ aε actua∞ examplσ oµ thei≥ data¼ observσ 'SAMPLDUN.TXTº iε thi≤ ì
subdirectory«  A≤ yo⌡ exi⌠ thi≤ program¼ pleasσ invoke:

             LIS╘ SAMPLDUN.TX╘  <============╜  Yo⌡ ente≥ this


ááá
Dun'≤ [TM▌ anΣ Dun'≤ Direc⌠ Acces≤ [TM▌ arσ trademark≤ oµ Thσ Duε ª
Bradstree⌠ Corporation«  Al∞ samplσ datß containeΣ iε 'SAMPLDUN.TXTº i≤ ì
propert∙ oµ Thσ Duε ª Bradstree⌠ Corporation.